UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wLTKqjO8dIoBx9/rIybZH2BKPswkMXPYCEcdrbTqgfI='
WHERE
key_id = '196a307afc5320392067a4a996aa6553ea0bf03a443dac4c5fa5604d5991547d'
AND (
token = 'wLTKqjO8dIoBx9/rIybZH2BKPswkMXPYCEcdrbTqgfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)