UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gUdDCPBFOi80z2gEpQT/hS5+VASavbX4mIMFgOl+foQ='
WHERE
key_id = '15c1c167e383177675e578518a8477cf28a77bf901f64b6bcfe3551e5d83f289'
AND (
token = 'gUdDCPBFOi80z2gEpQT/hS5+VASavbX4mIMFgOl+foQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)