UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LVCpKW6RBDr8v1B9pZwHgIcqCuZJtzSYZsIZ/nCeVtI='
WHERE
key_id = '6ad9b67e961d1362eb715375be5b51a156197fc8d1b5be4feb7e20adb4910ba8'
AND (
token = 'LVCpKW6RBDr8v1B9pZwHgIcqCuZJtzSYZsIZ/nCeVtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)