UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YcRoPo7pb4XMnJa6Uvrak6yjY5Fgs73HxZNMkhoMjwY='
WHERE
key_id = '16a78f2479d2b8b4fd8772812b7a4378984c1b220f6a2940d3d2654cd0cb2385'
AND (
token = 'YcRoPo7pb4XMnJa6Uvrak6yjY5Fgs73HxZNMkhoMjwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)