UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZdeiP956V+EMj3Ys9aI610m7nK6GsFQYKdDSDFTX90='
WHERE
key_id = '8abc12e8eaa6a2648a5e43741c1b6e6dd65621f63221dddf8f45a6a9359154c4'
AND (
token = 'nZdeiP956V+EMj3Ys9aI610m7nK6GsFQYKdDSDFTX90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)