UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sG/OYVlxbU/479e2d1hpmF8PanACmGJTvkiTOcGFIUs=' 
WHERE 
  key_id = '840a59b8bf4c2e1be8a1cf6ab01b760b6b07c7357bc11faa1b6cf61aea978dc0' 
  AND (
    token = 'sG/OYVlxbU/479e2d1hpmF8PanACmGJTvkiTOcGFIUs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020