UPDATE 
  cscart_product_popularity 
SET 
  `viewed` = 20, 
  `added` = 0, 
  `deleted` = 0, 
  `bought` = 0, 
  `total` = 60 
WHERE 
  product_id IN (
    514, 1505, 1506, 1507, 1508, 1509, 1510, 
    1511, 1512, 1513, 1514, 1515, 1526, 
    1527, 1528, 1529, 1530, 1531, 1532, 
    1533, 1534, 1535, 1536, 3675, 3727, 
    3728, 3730, 3731, 5210, 5211, 5212, 
    5213, 5214, 5215, 5216, 5217, 5218, 
    5219, 5228, 5229, 5230, 5231, 5232, 
    5233, 5234, 5235, 5236, 7496, 7497, 
    7500, 7501, 7506, 7507, 7528, 7529
  )

Query time 0.00281

Result

int(55)