UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lfx/mZ3nqUzzmEvAQmu/hC9SzN0dqzHjRF7fsbmXs7Y='
WHERE
key_id = '1f2825647c99ec08eee9e2e527c458550a98b0746f781325e2ab2e34d801a32a'
AND (
token = 'lfx/mZ3nqUzzmEvAQmu/hC9SzN0dqzHjRF7fsbmXs7Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)