UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e6CF9bj8Ja/nARJ8lIE14eoZ0t3N6534RYsCh+wHIyA='
WHERE
key_id = '83e403626bd8d2ee4d2b22b11797c9e450efec366512546635e38108f349e622'
AND (
token = 'e6CF9bj8Ja/nARJ8lIE14eoZ0t3N6534RYsCh+wHIyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)