UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bTheTvIdhxhKG067fQggv59nbadas4nIWD82dOSsYdI=' 
WHERE 
  key_id = '157619b2b1862e5811e078c660e593f20ec72f089cc824a413078c08bb6e92d3' 
  AND (
    token = 'bTheTvIdhxhKG067fQggv59nbadas4nIWD82dOSsYdI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00071