UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'H8gIIjy3wfE4pl7zt9cn//k1DFCVY99c0R9IAKEkuEM=' 
WHERE 
  key_id = 'd942c7cf8f214e8e1b35538c379952bd21af10ee1afbf6913ed23b8e6ef44dda' 
  AND (
    token = 'H8gIIjy3wfE4pl7zt9cn//k1DFCVY99c0R9IAKEkuEM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033