UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jrk/jOlj/VvwmIRWgWx0LjsnVGDrpA/uVFxU1o+h0Ag='
WHERE
key_id = '2921916e15bb0a43a483c750d986fdca19c5d43b944e3b7684fbb2e168c49589'
AND (
token = 'Jrk/jOlj/VvwmIRWgWx0LjsnVGDrpA/uVFxU1o+h0Ag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)