awk -F"[][]" '{cmd="date -d@" $2;cmd |getline $2; close(cmd)}1' infile
" Thu Oct 19 03:42:35 STD 2017 Auto-save of retention data completed successfully.",
" Thu Oct 19 04:42:35 STD 2017 Auto-save of retention data completed successfully.",
" Thu Oct 19 05:42:35 STD 2017 Auto-save of retention data completed successfully.",
" Thu Oct 19 06:42:35 STD 2017 Auto-save of retention data completed successfully.",
" Thu Oct 19 07:42:35 STD 2017 Auto-save of retention data completed successfully."
Here we set a shell command `date -d@$2` to a variable called `cmd`. Then with `cmd |getline $2` the `awk` reads a line and pass second field value to the `cmd` we open it, then we need close the command we opened via pipe, so we used `close(cmd)` here.