I have always understood the expression came from winding up a jack-in-the-box, which at a certain level of tension jumps out of the box. So being wound up (or worked up) means you are stressed at/near the point of exploding or lashing out, snapping at others... losing control of your emotions