1. Esplora never sets last_seen
2. Electrum workflow sets it even for transactions it sees as confirmed.

last_seen should be strictly set when the transaction is seen in the mempool. If you set it superfluously you create db churn. Every change to it is added to the changeset and written to disk.