UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qZAetpFDv6oOsIXRFLgQxN6Av1s1FJXnUTgGUr6ZDvg='
WHERE
key_id = '00473663155a3606bb9e17b8e8af6c5cb6b66bcd6139f7eb742d15ea39030568'
AND (
token = 'qZAetpFDv6oOsIXRFLgQxN6Av1s1FJXnUTgGUr6ZDvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)