Modify all array entries in all records of a table at once
You can update all the array entries like this:

UPDATE ambient_properties ap
SET recording_time = 
    (
        SELECT ARRAY(
            SELECT unnest(ap.recording_time) - interval '1 hours' 
        )
    );


The same strategy should also work for values of other types.

SQLFiddle