UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '79eBPILS3weBPQ+HBC/zctluYmCTsjNmCw2bKPrV+CU='
WHERE
key_id = '7d262cc176c650eca175988e1a3cef7959237695bfef6ca199e0de0fe6abc0d8'
AND (
token = '79eBPILS3weBPQ+HBC/zctluYmCTsjNmCw2bKPrV+CU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)