A Lion install removes the driver for the Tempo SATA E2P, Tempo SATA ExpressCard/34, and Tempo SATA edge ExpressCard/34. Just reinstall the driver and the card will work again.
Unfortunately, not. The driver was written by the 3Gb SATA controller chip maker, Silicon Image, and they no longer maintain the macOS driver for this chip.