UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eKnmuwmQ2GBg/l4hjQgF17Wp/V5JyFg8ApUPInaP2VU='
WHERE
key_id = '9e00f7bd2d84f9a692ae8a8a244cb03b18188c009f2c77f712fc6614a44b277d'
AND (
token = 'eKnmuwmQ2GBg/l4hjQgF17Wp/V5JyFg8ApUPInaP2VU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)