This is Paul Mason’s setting of “Be With Me, Lord” from his collection, Psalms for All Time.
This is the psalm for the first Sunday in Lent Year C, but is also a seasonal psalm for Lent. You could see a use with Anointing and in times a trial.
This would be a great song to use all through Lent either as the seasonal psalm or just as a hymn. He notes the refrain is in F#m but changes to a more hopeful A major in the verses. The chords go nice places as he modulates back and forth. If you don’t have the text in your missal it is the same as set by Kate Keefe.
There is a vocal performance, with cantor and SATB choir in the refrain, to listen to at the website that I would recommend. I still think it would survive the assembly singing the whole piece as a hymn. (ie cantor not essential)
I made a BIAB backing: