Damien Hirst's George Michael painting has sold for almost $600,000 (£477,000) at a charity auction in Texas.