Fix logic with DST. MySQL unixtime and R computed unixtime now are aligned 100%