检查列中的条件时PHP / MySQL表更新问题

I have the above table: tblCompInfo, the product_id value is not 100% accurate and I need to fix it. I have total of 543847 total row with 25 different company and 12 different products.I have the above table: tblCompInfo, the pro