UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RMs7CZ0anKxFcg2TdgGSrvK5JJKTCq5o1cgI+I50jlo='
WHERE
key_id = '67c49e0e6a7fad7d16f07c332bc95268c41e3a3da4310bbbe75aaca09672c143'
AND (
token = 'RMs7CZ0anKxFcg2TdgGSrvK5JJKTCq5o1cgI+I50jlo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)