UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+jPgNbJGla0iFQ7qFxyxhB8if9qGUOJKY+M1+LXc9t0=' 
WHERE 
  key_id = '3c2e4bc1dd03911b4d77cd9509de4a5116f0fc077209f1d60dbf0ab774817e01' 
  AND (
    token = '+jPgNbJGla0iFQ7qFxyxhB8if9qGUOJKY+M1+LXc9t0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029