UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'otPN5fFFg1h26RqIlWEnApogBqG/v4YpP+hYI3IEKAE=' 
WHERE 
  key_id = '138d5bf0677ffeb07d003d3fc151f9166cd4ae4e8bf03eac1e8a3b7d46f4320e' 
  AND (
    token = 'otPN5fFFg1h26RqIlWEnApogBqG/v4YpP+hYI3IEKAE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027