UPSERT

INSERT INTO users (id, email, last_seen)

VALUES (42, 'user@example.com', NOW())

ON CONFLICT (id)

DO UPDATE SET

  email = EXCLUDED.email,

  last_seen = EXCLUDED.last_seen,

  updated_at = NOW();