UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SNLkhIW2tCUKvrgh626nQ7i3gYFrae9bAZHOKP80qBo=' 
WHERE 
  key_id = 'fb3afe0e00bbcd5f8661dd6aba32cafafd999fd0396b74f92fa85de4dff6739d' 
  AND (
    token = 'SNLkhIW2tCUKvrgh626nQ7i3gYFrae9bAZHOKP80qBo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033