UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ua7BKtfrPWQ3YPyZNdX4Sx6N+2C+Vn5FkyBchOGzw1k='
WHERE
key_id = '2040c188124822c4ed20f18c0ee5e7df42607bc89e3214082eeee5e00f6af075'
AND (
token = 'Ua7BKtfrPWQ3YPyZNdX4Sx6N+2C+Vn5FkyBchOGzw1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)