UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XmeJxF6C3K2T297Sve57RNhwiJLMMxfHwivuqRPsAxM='
WHERE
key_id = '852cbbd70ad70ebd22e322be9b28c7a795ae06c1b351f51f53ca9512b824ddbc'
AND (
token = 'XmeJxF6C3K2T297Sve57RNhwiJLMMxfHwivuqRPsAxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)