UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QMEdLterjtqBZ2jYVkPdE1K2CzHgtmp8+pq9MyGoJAY='
WHERE
key_id = '0e9f54c8faaa801655545c7bd71002fd3e15e6efcfbc246e365be21ba44d81b3'
AND (
token = 'QMEdLterjtqBZ2jYVkPdE1K2CzHgtmp8+pq9MyGoJAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)