UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PmmjZuGpUJBY7cRV3m+ZXQeIsf/cyqn2VrfHYZwR/wc='
WHERE
key_id = '0fb2c091a91c2943e3e39e3f3eb5215b197fd11c3296e7810024a275417ab30e'
AND (
token = 'PmmjZuGpUJBY7cRV3m+ZXQeIsf/cyqn2VrfHYZwR/wc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)