UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qU25fJirk8JKbza5iROAve5NoWkejAe9+/mxoelWNvQ='
WHERE
key_id = '8350517a2c5e1cb8b9e91028306a304a75dc5b89441bbb5ec8bb9e44e3a5ffc5'
AND (
token = 'qU25fJirk8JKbza5iROAve5NoWkejAe9+/mxoelWNvQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)