My back is in so much pain

Ladies, I have had back pain since I was about 11 and it’s either a sciatic type of pain that comes and goes or it’s just soreness. This past period I have had has been insanely excruciating. I’m not sure why but there’s like a giant knot that I cannot for the life of me work out in my lower right back (it’s normally my left). Do any of you know a way for me to relieve this pain?? My boyfriend has been working crazy hours and is about to leave for the week so I don’t think I’ll be able to ask him to rub my back for me 😖 please help!