No. External power is not supported. The USB 3.0 ExpressCard prefers its internal 5V power to external 5V power and will not use an external 5V power source.
None of Sonnet's Cards with USB 2.0 or USB 3 (either Type A or Type C) ports support the Apple SuperDrive. You must use a built-in USB 2.0 or 3.0 port on your Mac.
According to http://support.apple.com/kb/HT5630, "The Apple USB SuperDrive is compatible with Mac models from 2008 and later that don't have a built-in optical drive."