This expression is used to describe how terrible and/or disgusting something is. In common usage, it is always preceded by the word 'like'.
"His hangover made him feel like warmed-over fuck."
"Dude, your house smells like warmed-over fuck. When was the last time you opened the windows?"