It makes alot of sense to me, that because of the usual stresses of the day, your muscles tighten up and are painful at night.
I find, stretching those painful muscles, thoroughly, relieves the pain and discomfort and helps to relax you, so that you can get to sleep.
Some people take a muscle relaxant at night (like Robaxin). I take the more natural approach, but also love Robaxin, when necessary.
Feel better, Friend..