I duplicated the tbl_product table as tbl_product2. Then I tried running the update against that table and it ran without issue.
I think you can simply delete the tbl_product table and rename the tbl_product2 table to tbl_product and it would resolve this issue. I tried renaming the tbl_product table but that times out as well. I didn't want to delete the table from my end since that seemed risky.
verify the data in the tbl_product2 table is complete and accurate and then try dropping the corrupt table and rename the new one.