Upgrade doing just override, and do module update in module manager. At once after upgrade install, module proceed database update (when upgrade from 1.7 or before).

Of cause, you make backup files and database if you warry.

However, I don't know what modification in your module. In upgrade, module will be working, but modification function to be lost.