Claire, try a deep freeze spray - bag of frozen veg you may find that eases it more than the heat. When my back goes on its jollies, I start with the freeze before the heat.
Sleeping, if you are sleeping on your side, put a pillow under the 'top' leg to raise it up (hope that makes sense!)
It's horrid, but you need to keep trying to move regularly.