UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ex/IbjWa+dCEeJtHWUJ70pLUEbaWJyWUyfSYM7V1pVo='
WHERE
key_id = '10a9387b8078b03d03e183d78cfeed726a0c96e87368fa780101616b41f0f858'
AND (
token = 'ex/IbjWa+dCEeJtHWUJ70pLUEbaWJyWUyfSYM7V1pVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)