UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1Waqg/VzNrOkuN1kpVrUSHtiTdWFA8aa7Na9P150HBI=' 
WHERE 
  key_id = '435156569c606103386ecdb8fdd3a35c518bb209b8cb41e3a0af67db8e91c7d0' 
  AND (
    token = '1Waqg/VzNrOkuN1kpVrUSHtiTdWFA8aa7Na9P150HBI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021