Hi Jay,
I’ll be around the space for a little bit tonight between 5 pm to maybe 7 pm. I actually have a few brand new Micro USBs like that one at my shop from an old project. Do you have a storage box? If you don’t reply I’ll live the USB on the wall in the electronics room by the pick and place for you. I could leave you this one and you could fully replace your port.
I would clean up all the solder off the board and make sure the holes where the tack down pins go are completely clean. Then put a dot on regular glue where the little hold down pad is. Place your new USB, solder the back pins, then flip the board and solder the back side of the hold down pins. Last wait a day or so for the glue to setup before using it. If you want to protect it from coming off in the future, 3d print a case that presses down on top of the USB port to keep it from levering up and breaking.