Merge tables with different timestamps?

I have two tables A and B. (Synology NAS, MariaDB if this is important)

Table A gets a new record every minute, table B gets a new record about every 2 minutes. Since table B has less entries I want to merge B into A. The problem is: the timestamps and also column names don't match!

Now I would like to have a query which matches the timestamp from B to the closest timestamp from A without creating duplicates or new rows.

Is this possible with a single query?

Example:

Table A

Table B

Table A Merged

The main question is how to match the rows of Table A and Table B.
I will assume that if the difference is less than 30 seconds, the rows can be considered comparable.

See example

select *
from TableA a
left join TableB b 
  on b.date between (a.date- interval 30 second) and (a.date+ interval 30 second)

The actual update

Update TableA a,TableB b 
set a.abc=b.xyz
where b.date between (a.date- interval 30 second) and (a.date+ interval 30 second)

select * from TableA;

fiddle