If this is the area of concern:
I would do some testing before trying to "replace" the pads. It is a multilayer board and at a minimum, contact on both visible sides can be important. It also looks like the lower pad is connected to the upper on each side. It looks like there is enough pad left on at least 3 of the 4 and perhaps all four to get a solder joint. I am assuming the component was on the side that is showing.
What does the other side look like? Presumably, that side looks OK.
I would confirm those assumptions by using an ohmmeter or conductivity tester on the pads. No need to poke through the solder mask at this time.
If the electrical connections are OK, I might do a little repair by tinning the component side a little, insert the new connector, solder from the back side as usual, and then check the top side to see if it got a little solder flow around the pins. Regardless of that, I would go ahead and test it. If it doesn't work, then I would consider trying to get a little solder on the top side; however, if the electrical checks are all OK, I don't think that will be necessary.