UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JHPoQOOyt6RJB51rVt3bWbae4EnH+DsgTrVHED7rrOg='
WHERE
key_id = '2f1fcdf760c30c36006587413d8b8b0a04bd52f636c5b048bc8662383d000f1a'
AND (
token = 'JHPoQOOyt6RJB51rVt3bWbae4EnH+DsgTrVHED7rrOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)