2 INSERT INTO subscription
3 (topic_id
, callback
, verified
, expires
, secret
, http_remote_addr
, http_from
)
5 (:topicId, :callback, strftime('%s', 'now'), strftime('%s', 'now') + :leaseSeconds, :secret, :httpRemoteAddr, :httpFrom)
6 ON CONFLICT (topic_id
, callback
) DO UPDATE
8 verified
= strftime('%s', 'now'),
9 expires
= strftime('%s', 'now') + :leaseSeconds,
11 http_remote_addr
= :httpRemoteAddr,