You could easily fix that with a reflow station.
It doesn't look like any of the pins snapped, it looks like whoever soldered that didn't make a full connection to the pins(That's why there's that like 90 degree J shape on the solder), and the 4 side square solder points were just holding it in place. What you need is some good ol' fashioned leaded solder and a rework station.
If I had that board I could fix that in about 5 minutes, but I don't have time to do that kind of work anymore.
EDIT: Looking at it again, none of the solder points made contact with the port. All of the solder points have no signs of brute force, it looks like you just knocked it off place. Whatever keyboard this is, please tell me, so I never buy one of their products.