UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ENNPADWndQZDv6odWYsWFSD9TbJCbZ127Suu4bYP9JQ='
WHERE
key_id = 'd6be2bf242bf441c95949e4b2211cea50d48a071a36be109daf67be122a4cb4b'
AND (
token = 'ENNPADWndQZDv6odWYsWFSD9TbJCbZ127Suu4bYP9JQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)