I have done this multiple times most of the time it runs pretty smooth HBA firmware and drivers doesn't impact SQL layer of files . If you have EMC its even more robust .

Above all you have active active , mine was active passive so we did failover check before and after HBA upgrade .

Backup of SQL is fine for extra precuation but not necessary .