UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'szYgr0Fdsp8fGjthR9uze1iSJgEp0sh9qPbBmiMrG9Y=' 
WHERE 
  key_id = '84ba4d1193c148d18466f573cb2884eb1be6c86638f77c1cc7f46783228eab8a' 
  AND (
    token = 'szYgr0Fdsp8fGjthR9uze1iSJgEp0sh9qPbBmiMrG9Y=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023