ON conflict (member_id) DO UPDATE SET

these functions above works like a so-called UPSERT (updates a field if it exists, inserts if it does not exist)

INSERT INTO accounts (id, token, affiliate_code) VALUES (value1, value2, value3) ON CONFLICT (id) DO UPDATE SET token = value2,