Is there a way to modify every URL in every granule for a collection from http://blah to https://blah without re-ingesting every record?

Something along the lines of:

update cmr_table set url = stuff(url,1,4,"https") where collection = "someSetOrOther" and url like "http://bah%"