This should be spaced out a bit more:

`$wpdb->prepare( 'SELECT * FROM `' . WPSC_TABLE_COUPON_CODES . '` WHERE coupon_code = %s', $code )`