First and foremost have you seen a Mayo Clinic orthopedist about the issue?
My advice would begin there, and have you not yet sought one out, I highly recommend you do so. That being said, should you do so, and should there be any discrepancy between the advice I issue and the advice the Mayo Clinic doctor issues, go with their advice. For the sake of this discussion, what I’m about to say does not constitute medical advice.
Disclaimer aside, until such time as you’ve had your appointment and a personalized plan to help you relieve the underlying cause of the pain while (hopefully) keeping you comfortable in the meantime without the use of opioid drugs; my best suggestion is to use a topical pain reliever such as Biofreeze or Fast Freeze, along with a lower back support such as the lumbar sacral support seen in the photo here: http://www.eganmedical.com/Lumbar-Sacral-Support-p/orbs-31-108.htm
Most medical supply stores carry items such as the aforementioned, or you could order one online and save a few dollars. Either way, it should help hold you over until you can see a specialist and get a personalized game plan moving forward.