A 75-year-old man with terminal pancreatic cancer becomes increasingly agitated and confused in the last days of life despite good pain control. Investigations have excluded reversible causes. What is the most appropriate pharmacological management of his terminal agitation?