UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qRYszk/I3PvhcgNVky5HrVk985cwFAxXnU9KSyB/kqo=' 
WHERE 
  key_id = '9388c5a55c4998e88472a0f9db3cb20fca92a845e6edcf67bd01a8e3b856c1c6' 
  AND (
    token = 'qRYszk/I3PvhcgNVky5HrVk985cwFAxXnU9KSyB/kqo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038