UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3dYA0O1KYsJWBgzOKvyAJn+rAcvW4u40TIK0ALFbYm0=' 
WHERE 
  key_id = '5a3b6eed800d8b17766d326eedc44c26d9b9db9a80cc4e2b0c9d61b5b3dca9cd' 
  AND (
    token = '3dYA0O1KYsJWBgzOKvyAJn+rAcvW4u40TIK0ALFbYm0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029