Constraining the Properties of the Interstellar Medium in Luminous Active Galaxies Through Observations of Carbon Monoxide and Atomic Carbon