UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TXjKxG+/RPm8zgZca0+X0TENNQtPRPYb5S7vcRv/R/E=' 
WHERE 
  key_id = 'e3a1f1ce8be0279239d788a7768ac7b122af2e3619ec0dd45af7e7ff4f53222a' 
  AND (
    token = 'TXjKxG+/RPm8zgZca0+X0TENNQtPRPYb5S7vcRv/R/E=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019