UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3wAnvbOgn2W2Laca+37jnUJtXFVhVT0c0k+ZF9OExpU=' 
WHERE 
  key_id = '040ff97649bfa7305defc853cbe31cd51b0f8f18df53057151e76eb0c90a7623' 
  AND (
    token = '3wAnvbOgn2W2Laca+37jnUJtXFVhVT0c0k+ZF9OExpU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043