I was able to power my SCSI2SD using the USB on it. I had to buy an adapter that went from molex to USB:
https://www.amazon.ca/gp/product/B082FB2WK6/
My power connector on the card stopped working too, so I'm left with using power from the SCSI cable or the USB connector. I picked USB.
J