UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3/CU4KD/qN2Fz/rCC59S4p3ids/r36uvqrZtKUJjn4E=' 
WHERE 
  key_id = '9d75d3966fdc65c03c216652a1ccf0c3e48be5d927ee51afde37b67e78de60ce' 
  AND (
    token = '3/CU4KD/qN2Fz/rCC59S4p3ids/r36uvqrZtKUJjn4E=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034