UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xqGZHjn8ESEUwNvF7jlwkQwfD50SJw32/qSuA9lxdQA='
WHERE
key_id = '39ab22c9f42fd6ce302cce520c0d7976f2a5f55a5aba3ded8dded3f1e86a869c'
AND (
token = 'xqGZHjn8ESEUwNvF7jlwkQwfD50SJw32/qSuA9lxdQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)