UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aujx5NxGazNzyywkUUi5nQKgpyIPmFkeblHmt+7y6eg='
WHERE
key_id = '8047766deb71c5a6f8a8b48b77fa16255b566802be7cbaee5a4c7c349c63b9d6'
AND (
token = 'aujx5NxGazNzyywkUUi5nQKgpyIPmFkeblHmt+7y6eg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)