UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jrMosHIuuk7ORwobDKGGMA/POJQ6SqMNP/DIFSZD9yw='
WHERE
key_id = '87d4c80a65fb43eaa9daa0d8233fd3ec7346579b3ad8887d5a8e796be1fa2479'
AND (
token = 'jrMosHIuuk7ORwobDKGGMA/POJQ6SqMNP/DIFSZD9yw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)