The first time I came across the usage of this phrase was in the movie Hellraiser, and I had no idea this was a common saying. Clearly though, there must be a double meaning there in the movie that I couldn’t fully grasp without knowing the more colloquial meaning.
The description on Wikipedia is unfortunately not enough for me, I would like to see examples. And it’s very hard to find those because Google gives me mostly links to religious websites.
It’s something you would say when everything seems to be going wrong at once. Honestly I don’t think it’s a super common saying. I’ve only really ever seen it used in books and movies.