UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PNCV14YN2LevPWcr+uPlfdyyU5svv3kJ0AK39QtIPhE=' 
WHERE 
  key_id = 'f99a8c6073844898b23140c32f22815935a996a96361d2516e55abc8fa715b04' 
  AND (
    token = 'PNCV14YN2LevPWcr+uPlfdyyU5svv3kJ0AK39QtIPhE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043