UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4ZaC4LNGOQs3Jwds34ioDVSMEKDxPHgSnIGdQMnuaCU=' 
WHERE 
  key_id = '626652b0a8439b6ef773f36738d1b88a0d7492f7484b0c7dcede4b377ec3ad7d' 
  AND (
    token = '4ZaC4LNGOQs3Jwds34ioDVSMEKDxPHgSnIGdQMnuaCU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019