UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TCJbtNk35HF4Ti6bhRlfK79NuAnDBzlCiR7f4af72zM=' 
WHERE 
  key_id = 'e93ca321d45a6c7a6609eb0d72a8f591130351e0857d72ec70e42defa77fc720' 
  AND (
    token = 'TCJbtNk35HF4Ti6bhRlfK79NuAnDBzlCiR7f4af72zM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041