UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '//EX3hoDSGamGa6e8L2qutu7+dJ/xUcb4hkGOz1SWKo='
WHERE
key_id = 'aec75711b167ec286b187e2a95554ce9016893b4c191f199b58e5ca0aeed0793'
AND (
token = '//EX3hoDSGamGa6e8L2qutu7+dJ/xUcb4hkGOz1SWKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)