UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PCyjwOhZIkO/x72Ngu6j9e2MTS8EP2SNovlktiXdKZ0=' 
WHERE 
  key_id = '3f0a1e95deb05e51ae02a4537e354dfc3ffb0fdaa83278df471dc7b650465126' 
  AND (
    token = 'PCyjwOhZIkO/x72Ngu6j9e2MTS8EP2SNovlktiXdKZ0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029