I too have had these extremely painful spasms, and have been unable to move for some time immediately afterwards.
Got stuck in the shower once and couldn't even turn it off initially.
My big breakthrough on these spasms and general muscle pain and tightness came from taking high doses of magnesium chloride. You may well be deficient in this mineral and muscle spasms are a sign of it.
You can get tablets, powder and liquid versions. Do some research first as some aren't that good, and there are several different chemical types on sale.
I have found chloride works well for me. Took effect in about a week.