You're more likely to suffer an issue from outside forces (eg. sudden power loss) than the firmware update, and those odds are extremely low...unless you do something ridiculous like updating during a lightning storm with no UPS.
I've done three firmware updates to my 840 EVO since I got it, none were destructive.