UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/tqJR9brKWw78vgg09vedq+SZq/DK0vNpe8N/bPnmW4='
WHERE
key_id = 'd56834f0f1852945fb760a5a6016acfa35255110b84c72c39943ac528bbbd4a2'
AND (
token = '/tqJR9brKWw78vgg09vedq+SZq/DK0vNpe8N/bPnmW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)