Update record with converted epoch timestamp from another column
Your timestamp_epoch is defined with the data type text (which is what "function to_timestamp(text) does not exist"  is telling you). 

You need to first convert your text value to a bigint:

to_timestamp(timestamp_epoch::bigint) AT TIME ZONE 'EST'