UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j6DQQ/U/8ywyL9qCUDKipBwe/jkZCPuOV59bcnoQdcE='
WHERE
key_id = 'ca32a075ae6b70f3d24c10efdfa51fa77073e1de944016f5b254c61bcdb1c2a3'
AND (
token = 'j6DQQ/U/8ywyL9qCUDKipBwe/jkZCPuOV59bcnoQdcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)