UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+Jv7NjwMW9+ZLTwVlZNNRL2ER9ngbq4rYEdS08aSoAw='
WHERE
key_id = 'af0b087ecc63f06e230ed14394f9a0b33d6188962311b1e7e0b4556957ca14aa'
AND (
token = '+Jv7NjwMW9+ZLTwVlZNNRL2ER9ngbq4rYEdS08aSoAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)