UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c+Hv0n+7u9OaNZUoABZcdtTbulJFfX7ubqAt+m3VRCE='
WHERE
key_id = '3c09f2fd2df164c192e9325f9a1e8259002f8ca7bb1ab04dde3f46d51439be21'
AND (
token = 'c+Hv0n+7u9OaNZUoABZcdtTbulJFfX7ubqAt+m3VRCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)