UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MzsgVA9Zx88Phd6HDP44N2o1StQ0Eecr6WnPsCLHo4Y=' 
WHERE 
  key_id = '4ea45b7e2b6eb5d87222ff4ba01af783a1f5a5b8e5f4c73bb5eeef1cd10ab8c7' 
  AND (
    token = 'MzsgVA9Zx88Phd6HDP44N2o1StQ0Eecr6WnPsCLHo4Y=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00066