UPDATE stock SET unit_price = CASE 

 WHEN stock_num = 1 

 AND manu_code = "HRO" 

 THEN unit_price * 1.2 

 WHEN stock_num = 1

AND manu_code = "SMT" 

 THEN unit_price * 1.1 

 ELSE 0 

 END