id | cat_code | item_code
-------------------------
1  | ACR001   | SUP-001
2  | ACR001   | SUP-001
3  | ACR001   | SUP-001
4  | ACR001   | SUP-001
5  | BCR001   | COM-001

UPDATE table SET cat_code = 'NEWVALUE', item_code = 'NEWVALUE' WHERE cat_code = 'ACR001' AND item_code = 'SUP-001'

UPDATE table SET `Field_name`= 'new_value' WHERE cat_code = 'ACR001' AND item_code = 'SUP-001'