UPDATE 
  ushop_products 
SET 
  enable_offer = 'E' 
WHERE 
  product_id IN (345, 346, 347, 348, 349)

Query time 0.00035

Result

bool(true)