UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cAsfAFCFVgIgqIa7S7Gya93PUnb+W34pJSHlB9KiglI='
WHERE
key_id = '87d0c65b4561f556a6543097b123b42e842271dc838143f04d1f7814035dc98e'
AND (
token = 'cAsfAFCFVgIgqIa7S7Gya93PUnb+W34pJSHlB9KiglI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)