NAD. Massage therapy grad and have dealt with this myself for years. Get this book: https://www.amazon.com/dp/1608824942/ref=cm_sw_r_sms_c_api_i_PR0f and see if you can find a massage therapist who is knowledgeable about dealing with trigger points.
Buy this book.
I'd tried a bunch of different things, and understanding how trigger points work and how to treat them has been really helpful.
I would also check to see if you have anterior pelvic tilt; that puts a lot of extra stress on the back muscles.
https://www.amazon.com/Trigger-Point-Therapy-Workbook-Self-Treatment/dp/1608824942 that's the version I have -- when combined with a proper PT program to address any major mechanical deficits (I had a poorly positioned pelvis that was wreaking all kinds of havoc) you should be able to get back to what you love. I was literally in pain every step for years and now can do any kind of athletic activity I want, so there's hope!
First off, stop riding if you are in that much pain, and lay off the Ibuprofen. It's not good on an ongoing basis.
Things to think about:
Note that backs are a bit strange; you can have chronic issues and not really notice them and then you do something and you start getting acute pain. Waiting for the pain to go away doesn't fix the underlying chronic issues and means you are likely to get more pain in the future.
40 was when I really noticed that I needed to be more diligent in my training. I'm 55 now, and I stay in shape by never getting out of shape.
Backs are weird things. My experience is that rest might get the back pain to go away, but unless you address the underlying issues, it's going to keep coming back.
Big contributors for me were:
The first two were from sitting too much and too much time on the bicycle.
It took a lot of work and some PT to get to a space where my back is generally not an issue for the activities that I do. I especially recommend the Trigger point therapy workbook.
Try the TMJ treatments in this book.
I used it for my carpal tunnel/TOS worked wonders
Also you can search “jaw-neck sequence” by kit Laughlin on YouTube
Let me know how it goes