UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '72y5cJhfF31Af/34pbFtJ3B69CTdijxyjixKnvAsv3k='
WHERE
key_id = 'cb2b18513f6732dc73a5b31b36f6f7afb11b888079cc65006aedaba476183fcf'
AND (
token = '72y5cJhfF31Af/34pbFtJ3B69CTdijxyjixKnvAsv3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)