How database engine of SQL swap two columns values?

I want to swap values of two columns in a table, And I found that in SQL we can do that by using Update:

update the_table set first_name = last_name, last_name = first_name;

It works But I wonder How SQL can do that without **overwrite** data in a column of other column?