UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'uk+SrxRfhlMsbYd/MAwlsK/lc9PFTavVH0ASrbgzQJY=' 
WHERE 
  key_id = 'eec8e504a09196d19df37070c5b9de67497c6ca3bff8ef32045565098fc097be' 
  AND (
    token = 'uk+SrxRfhlMsbYd/MAwlsK/lc9PFTavVH0ASrbgzQJY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035