UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pjtv72Q2nDAYokDi7AuwKzLKimT7pdyNpYrPwD7RCjE='
WHERE
key_id = '12640ddb0587b9503e47ec0a301315166d8b1cc09c4ee2bd2c673a7c2e5f347e'
AND (
token = 'pjtv72Q2nDAYokDi7AuwKzLKimT7pdyNpYrPwD7RCjE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)